A dataviz makeover post.
A makeover of a data visualisation created from data provided by Department of Statistics, Singapore (DOS).
The current data visualisation above can be found in this link. The data is available under the sub-section of Merchandise Trade by Region/Market.
| S/N | Critiques | Suggestions |
|---|---|---|
| 1 | The top net exporter and top net importer icons within the graph looked too similar to the country bubbles and can create confusion that they are separate countries at first glance. |
Use tooltip to indicate the top net exporter and top net importer country respectively. |
| 2 | There are too many colours used that impairs the reader’s pre-attentive processing. The colours in the graph were also inappropriately used, affecting the clarity of the data visualization. For instance, the graph differentiated the export and import categories with green and blue respectively but also used green to represent some countries such as Malaysia and the United States. Readers might misinterpret that those countries in green bubbles are net exporters. Furthermore, while the current data visualization might have intended to use different colours to differentiate the countries, this was also not consistently applied as both Thailand and EU were represented by purple bubbles. |
The colors should be used to serve a particular communication goal. Use blue and red to represent whether the countries are net exporters or net importers.The color intensity can differ based on the balance of trade value. The opacity of the colors can be reduced so that readers can still see different country bubbles even if they overlap. |
| 3 | Missing x-axis and y-axis for the data visualization. Without the x-axis and y-axis labels, readers cannot ascertain if they are percentile values or actual values. The units of the numbers in the axis were also missing so it is unclear whether they are represented in millions or billions or some other scale. |
Include the x-axis and y-axis for the data visualization. |
| 4 | It is hard to read the white font against the light blue information bar as the colours are not contrasting enough. | Use dark fonts against a white or light background to maximise contrast and improve readability. |
| S/N | Critiques | Suggestions |
|---|---|---|
| 1 | Data-ink is not appropriately used. For instance, the data-ink is used for the lines on the axis and not emphasizing on the values of the axis. |
To remove unnecessary non data-ink and emphasize the remaining data-ink. |
| 2 | The current data visualization’s scatterplot bubbles are all clumped together, affecting the readability of the data visualization. |
Use percentile instead of absolute values to plot the countries on the import vs export axis. This will allow the scatterplot to be more spread out and improve aesthetics and readability of the visualization. |
| 3 | To quote Leonarda Da Vinci, “Simplicity is the ultimate sophistication”. The data visualization, though colourful, is not visually aesthetic as it is overcrowded with too many visual information such as a background with two separate colours; multiple colours to represent different countries; white arrows to explain the concept of export vs import and white centre point in the bubbles to facilitate readers’ interpretation of whether the countries fall within the net importer or net exporter section. |
With the interactivity of charts, include tooltips to convey all those additional key information and even embed charts to further drill down on some information. Have a single background color for the main data visualization chart(s). |
| No | Step | Action |
|---|---|---|
| 1 | Load the outputFile excel file into Tableau Desktop after renaming ‘T1’ and ‘T2’ to ‘Import and ‘Export’ respectively. Drag the ‘Import’ and ‘Export’ worksheets from the left pane to the canvas. |
|
| 2 | Create a relationship connection by connecting import variables with export variables. | |
| 3 | Select all the columns outside the desired period of Jan 2011 – Dec 2020 and hide those columns. | |
| 4 | Pivot the columns of 2011 Jan – 2020 Dec. | |
| 5 | Change the variable type for the date column from ‘String’ to ‘Date’ and rename the column to Date. | |
| 6 | Change the variable type for the date column from ‘String’ to ‘Number (whole)’. | |
| 7 | Create a calculated field for export value. The export value will be ‘Pivot Field Values’ multiplied by 1000 in order as ‘Pivot Field Values’ are currently in units of thousands. | |
| 8 | Create a column for the trading partner’s name without ‘(Thousand Dollars)’ by clicking on ‘Split’. | |
| 9 | Hide the ‘Variables (Exports)’ and ‘Pivot Field Values’ Columns. Rename all the other column names as shown in the image. Repeat steps 1-9 after clicking on the ‘Imports’ logical table in the canvas. |
|
| 10 | Add the date field (import date = export date) in the relationship link at the canvas section. | |
| 11 | For Chart 1, create a new worksheet and name it Merchandise Trade Value. Drag ‘Sum Export’ to the column shelf and ‘Sum Imports’ to the row shelf. Add import and export countries to the Marks card. Select ‘Edit table calculation’ and change calculation type to percentile, computing using specific dimensions of both ‘Export countries’ and ‘Import countries’. |
|
| 12 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Total Trade’. | |
| 13 | Drag ‘Total Trade’ to the size segment in the Marks card. | |
| 14 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Balance of Trade’. | |
| 15 | Drag ‘Balance of Trade’ to the color segment in the Marks card. Select red-blue diverging palette with full color range and center at 0. | |
| 16 | Drag ‘Balance of Trade’, ‘Total Trade’, ‘Export’, ‘Import’ variables onto the detail segment in the Marks card. | |
| 17 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Net Exporter’. | |
| 18 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Net Importer’. | |
| 19 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Rank Net Exporter’. | |
| 20 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Rank Net Importer’. | |
| 21 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Rank Total Trade’. | |
| 22 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Top Net Exporter’. | |
| 23 | Under ‘Analysis’, select ‘Create Calculated Field’ to create a new variable called ‘Top Net Importer’. | |
| 24 | Add all the variables created in steps 17 – 23 as well as ‘Year’ variable to the detail segment in the Marks card. | |
| 25 | Create a new worksheet with the title ‘Balance of Trade by Quarter’. Drag ‘Quarter (Import date)’ to the columns shelf and ‘Balance of Trade’ to the rows shelf. Change the chart type to ‘Bar’ under the Marks card. Drag another ‘Quarter (Import date)’ to the columns shelf and ‘Balance of Trade’ to the rows shelf. Change the chart type to ‘Line’ under the Marks card. Change the color of the line graph to orange. |
|
| 26 | Right click on the y-axis and select ‘Dual Axis’. | |
| 27 | Right-click on the secondary y-axis and select ‘Synchronise Axis’ and uncheck ‘Show Header’ | |
| 28 | Drag ‘Balance of Trade’ to the color segment in the Marks card. Select red-blue diverging palette with full color range and center at 0. | |
| 29 | Drag ‘Balance of Trade’ to the label segment in the Marks card. Click on label icon in the Marks card to check for any required adjustments on label formatting. | |
| 30 | Create a new worksheet with the title ‘Quarterly total Trade. Drag ‘Quarter(Import date)’ to column shelf and ‘Total Trade’ and ‘Measure Values’ to rows shelf. Keep only ‘Export’ and ‘Import’ variables in ‘Measure values’. | |
| 31 | Add ‘Measure Names’ to color segment in the Marks card. Add ‘Measure Names’ and ‘Measure Values’ to label segment in the Marks card. Click on label icon in the Marks card to check for any required adjustments on label formatting. | |
| 32 | Edit the tooltip in the ‘Merchandise Trade Value’ worksheet. Insert the worksheets ‘Quarterly Total Trade’ and ‘Balance of Trade by Quarter’ in the tooltip. | |
| 33 | Under the data pane, select create parameter. | |
| 34 | Create a ‘Top N Total Trade’ parameter with the following properties and range of values. | |
| 35 | Right click on the import countries variable and select create set. Create a Top N by Total Trade set and select ‘Top N Total Trade’ parameter in the top tab. | |
| 36 | Drag the ‘Top N By Total Trade’ set to the filters card. Right click on the variable in the filter and select ‘edit filter’. Select ‘In’ option in the in/out membership filter. | |
| 37 | Drag the ‘Year(Import date)’ to the filters card. Right-click on the year filter and select ‘Show Filter’. | |
| 38 | Select single value (list) option for the filter and uncheck show ‘all’ value under the customize option. | |
| 39 | Right click on the ‘Top N by Total Trade’ parameter and select ‘Show Parameter’. | |
| 40 | Create a new worksheet titled Balance of Trade, 2011 – 2020. Drag ‘Year(Import Date)’ to columns shelf and repeat steps 26 – 29. | |
| 41 | Create a new worksheet titled ‘Export and Import by months’. Drag the ‘Month(Import date)’ to column shelf and ‘Export’ and ‘Import’ to rows shelf. Drag Measure Names to color and label segment of Marks card. Select ‘red’ for import and ‘blue’ for export under ‘edit colors’ of color segment. |
|
| 42 | Create a new worksheet titled ‘Quarterly Heat Map – Balance of Trade’. Drag ‘Quarter(Import date)’ to columns shelf. |
|
| 43 | Drag ‘Balance’ of Trade to Color segment of Marks card. Edit colors to red-blue diverging with full color range and center at 0. | |
| 44 | Drag ‘Balance’ of Trade to Label segment of Marks card. | |
| 45 | Create a new worksheet titled ‘Monthly Heat Map – Balance of Trade’. Drag ‘Quarter(Import date)’ to columns shelf. Thereafter, repeat steps 43 to 44. |
|
| 46 | Edit tooltip to insert ‘Export and Import by months’, ‘Quarterly Heat Map – Balance of Trade’ and ‘Monthly Heat Map – Balance of Trade’ worksheets in ‘Balance of Trade, 2011 – 2020’ worksheet. | |
| 47 | Create a new worksheet titled ‘Total Trade, 2011 – 2020’. Drag ‘Year(Import date)’ to columns shelf and ‘Total Trade’ to rows shelf twice and repeat steps 26 to 29. |
|
| 48 | Drag ‘Total Trade’ to Color segment of Marks card and edit colors, selecting a green palette. | |
| 49 | Drag ‘Total Trade’ to label segment of Marks card. | |
| 50 | Create a new worksheet titled ‘Quarterly Heat Map – Total Trade’. Drag ‘Quarter(Import Date)’ to columns shelf and ‘Total Trade’ to colors and label segment of Marks card. |
|
| 51 | Create a new worksheet titled ‘Monthly Heat Map – Total Trade’. Drag ‘Month(Import Date)’ to columns shelf and ‘Total Trade’ to colors and label segment of Marks card. |
|
| 52 | Edit tooltip to insert ‘Quarterly Heat Map – Total Trade’ and ‘Monthly Heat Map – Total Trade’ worksheets in ‘Total Trade, 2011 – 2020’ worksheet. | |
| 53 | Create a new worksheet titled ‘Info’. Create a calculated field ‘i’. | |
| 54 | Drag the ‘i’ pill to Marks card and change the chart type to shape. Select the downloaded info shape palette and click ‘ok’. For more details, Refer to this link on how to add custom shape filters on your dashboard. |
|
| 55 | Edit tooltip. | |
| 56 | Drag ‘Merchandise Trade Value’ sheet to the top of the dashboard, ‘Total Trade, 2011 – 2020’ sheet to the bottom left of the dashboard and ‘Balance of Trade, 2011 – 2020’ to the bottom right of the dashboard. | |
| 57 | Under ‘Dashboard’, select actions. Click on add action and input the filter action. |
Please view the proposed visualisation on Tableau Public here.
This could be due to the impact of COVID-19 on the trading activities between Singapore and the United States. In Q1 2020, United States were still a net importer but by Q2 2020, there was a combination of a sharp drop in imports from United States and a sharp increase in exports to United States, changing United States to Singapore’s net exporter. This trend widened in Q3 2020 with the difference in imports and exports being the widest in July 2020. The fall in total trade in 2020 relative to 2019 was cushioned by a strong Q1, a period before the outbreak wave grew in United States. In Q4 2020, the difference in imports and exports narrowed as compared to Q3 2020 with increasing imports and decreasing exports.
| Malaysia | China |
|---|---|
| 2020 | 2019 |
|---|---|
| Malaysia | China |
|---|---|
Taiwan’s total trade were even higher in 2020 as compared to 2019, bagging the highest total trade value with Singapore in the 2011-2020 period. In 2020, exports to Taiwan fell in Q2, coinciding with Singapore’s circuit breaker period and the rise in COVID-19 cases in Singapore. However, imports from Taiwan rose steadily through all quarters in the year.
While the same top 10 trading partners stayed in the top 10 list from 2011 – 2020, most of their rankings has changed at least once in the same period. Some of the countries have changed so much in terms of their ranking that they even move across different quartiles of the import, export scatterplot graph.
One example is Taiwan. Taiwan ranked number 9 in terms of total trade value with Singapore in 2011 but rose to number 5 in 2019, moving from the bottom left-hand quartile of the graph to the top left-hand quartile of the graph, indicating that Singapore is now importing from Taiwan at a higher-than-average annual total import value as compared to the top 10 trading partners.
Another example is Indonesia. It fell from being the top 4 trading partner in 2011 to the top 7 trading partner in 2019. Singapore’s export value with Indonesia used to be higher than average as compared to the top 10 trading partners in 2011 (bottom right-hand quartile) but in 2019 (bottom left-hand quartile), Singapore exported a less than average total export value to Indonesia as compared to its top 10 partners.
Note: 2019 is selected for comparison with 2011 instead of 2020 when observing the relative movement of the countries in this period as 2020 is the COVID-19 pandemic year and there might be some unexpected fluctuations/trading performance in that year.
2019:
2011:
| 2011 | 2019 |
|---|---|